How to: Create a field that automatically generates numbers.
Solution:
In the Table Design view, insert the field, and type a name for the field. Then select 'AutoNumber' from the drop-down list in the 'Data Type' column.
1) If the Database window is not active, activate the Database window.
2) Go to the Table Design view.
3) To insert a field, click in the next blank row.
4) Type a name for the field in the 'Field Name' column.
5) Click in the 'Data Type' column. (A down arrow appears.)
6) Click on the arrow in the 'Data Type' column. (A drop-down list appears.)
7) Select 'AutoNumber' from the drop-down list.
Data type
8) Move to the 'Field Properties' section.
Field Properties section
9) Click the 'General' tab.
10) Make the desired entries and selections.
NOTE 1: To create an incrementing AutoNumber, do NOT change the properties in the 'Field Properties' section. By default, the 'Field Size' property is already set to 'Long Integer', and the 'New Values' property is already set to 'Increment'.
NOTE 2: To create a random AutoNumber of the Long Integer type, select 'Random' from drop-down list in the 'New Values' property box.
11) Select the 'File' menu and select 'Save' to save changes.
12) Select the 'File' menu and select 'Close' to close the Table Design view.
